package com.pan.dao.order2;

import com.pan.entity.OrderTable2;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface OrderTable2SelectDao{
    OrderTable2 selectById(Long id);
    List<OrderTable2> selectByPid(Long pid);
    List<OrderTable2> selectByFreightId(Long freightId);
    List<OrderTable2> selectByGoodsId(Long goodsId);
    List<OrderTable2> selectByGoodsCount(Integer goodsCount);
    List<OrderTable2> selectByGoodsPrice(Double goodsPrice);
    List<OrderTable2> selectByTotalAmount(Double totalAmount);
    List<OrderTable2> selectByPriceReduction(Double priceReduction);
    List<OrderTable2> selectByScorePriceReduction(Double scorePriceReduction);
    List<OrderTable2> selectByCouponPriceReduction(Double couponPriceReduction);
    List<OrderTable2> selectByGiftScore(Integer giftScore);
    List<OrderTable2> selectByGiftGrowth(Integer giftGrowth);
    List<OrderTable2> selectByOrder2Status(Integer order2Status);
}